Exam 77-420 Microsoft Excel 2013 3. Create Advanced Formulas 3.1 Apply Functions in Formulas: Use Nested Functions

Review the Formula 4. Do This: Review the NESTED Formula Select Cell C2 and review the NESTED Formula. E Where does one Formula start and the next begin? What are the clues? Begin with the Order of Precedence. A NESTED function is placed within parenthesis. So the Function starts with IF()*. In the first IF Function: B2>=10500 is the Logical_Test 0.2 is the Value_if_true IF(B2>=7500 replaces Value_if_false with another IF Function. * There are four parentheses on the right: one to close each IF() statement.   Something to Consider: Sometimes a complex NESTED formula can be simplified by a Lookup Table. Please review the vLookup Table we did earlier, on page 115.   The Computer Mama Sez: Some formulas can literally fill a page in Microsoft Word at 14 pt type. I have often pasted loooong expressions into Word and formatted each Function a different color so that I can see them separately. Formulas ->Function Library-> Logical->IF